select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Green Floor-length Quinceanera Dresses with Ruches and Flower
Ball Gown Taffeta Pick-ups Quinceanera Dresses with Ruches
Luxury and Grace Purple Ball Gown Princess Quinceanera Dresses
Eye-catching Apple Green Ball Gown Taffeta and Tulle Quinceanera Dresses
Lovely Watermelon Ball Gown Strapless Sweet Sixteen Quinceanera Dresses
Most Gorgeous Burgundy Ball Gown Sweetheart Quinceanera Gown Dresses
Pretty Apple Green Sweetheart Ball Gown Dresses For a Quinceanera
Delightful Lawn green Ball Gown Sweetheart Dresses For a Quinceanera
Classic Teal Blue Satin Ball Gown Dresses For a Quince with Appliques
Exquisite Embroidery Royal Blue Ball Gown Dresses For a Quinceanera
Ball Gown Sweetheart Quinces Gown with Beading in Organza
Navy Blue Ball Gown Strapless Dresses 15 with Pick-ups and Beads
Eggplant Purple Ball Gown Strapless Floor-length Dresses 15 with Ruffles
Light Purple Sweetheart Sweet Sixteen Quinceanera Dresses Beaded
Dark Purple Halter Top Quinceanera Dress with Beading and Embroidery
Fuchsia Strapless Prom Evening Dress with Silver Appliques
Hot Pink weetheart Quinceanera Dresses Gowns Appliques Lace Up
Champagne Sweetheart Sweet Sixteen Dresses With Layers of Ruffles
Ball Gown Sweetheart Beaded Navy Blue Sweet Sixteen Dresses
Ball Gown Sweetheart Ruffled Appliqued Purple Dresses for 15
Teal Ball Gown Strapless Embroidery Quinces Dresses
Pick Ups Beaded Coral Red Sweetheart Quinceanera Party Dress
Cheap Baby Blue Sweetheart Floor-length Appliqued Quinceanera Dress
Two-toned Ball Gown Beaded Floor-length Sweet 15 Dresses for Ellen Page
Spring Green and White Ball Gown Beaded Sweet 15 Dresses
Embroidery Sweetheart Organza Dresses Quince with Appliques
Colorful Floral Appliques Spring Green Strapless Dress for 15
Multi-colored off the Shoulder Dress for Sweet 16 with Appliques
Embroidery Appliques Hand Made Flowers Light Yellow Dress 15
Unique Pale Green Ball Gown Tulle Sweetheart Beaded Dresses 15